/*
 Navicat Premium Data Transfer

 Source Server         : 192.168.1.105
 Source Server Type    : MySQL
 Source Server Version : 50644
 Source Host           : 192.168.1.105:3306
 Source Schema         : gpmall

 Target Server Type    : MySQL
 Target Server Version : 50644
 File Encoding         : 65001

 Date: 09/08/2019 23:09:54
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tb_address
-- ----------------------------
DROP TABLE IF EXISTS `tb_address`;
CREATE TABLE `tb_address` (
  `address_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) DEFAULT NULL,
  `user_name` varchar(255) DEFAULT NULL,
  `tel` varchar(255) DEFAULT NULL,
  `street_name` varchar(255) DEFAULT NULL,
  `is_default` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`address_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of tb_address
-- ----------------------------
BEGIN;
INSERT INTO `tb_address` VALUES (3, 63, 'test', '18782059038', '四川省成都市青羊区百花中心站对面', 1);
INSERT INTO `tb_address` VALUES (5, 63, 'admin', '18782059038', '上海青浦区汇联路', 0);
INSERT INTO `tb_address` VALUES (6, 62, 'Mic', '18073804421', '湖南省长沙市麓谷企业广场A3栋3单元407', 0);
COMMIT;

-- ----------------------------
-- Table structure for tb_base
-- ----------------------------
DROP TABLE IF EXISTS `tb_base`;
CREATE TABLE `tb_base` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `web_name` varchar(255) DEFAULT NULL,
  `key_word` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `source_path` varchar(255) DEFAULT NULL,
  `upload_path` varchar(255) DEFAULT NULL,
  `copyright` varchar(1000) DEFAULT NULL,
  `count_code` varchar(1000) DEFAULT NULL,
  `has_log_notice` int(11) DEFAULT NULL,
  `log_notice` varchar(1000) DEFAULT NULL,
  `has_all_notice` int(11) DEFAULT NULL,
  `all_notice` varchar(1000) DEFAULT NULL,
  `notice` varchar(8000) DEFAULT NULL,
  `update_log` varchar(8000) DEFAULT NULL,
  `front_url` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_base
-- ----------------------------
BEGIN;
INSERT INTO `tb_base` VALUES (1, 'GPMALL后台管理系统 v1.0', 'GPMALL后台管理系统 v1.0,GPMALL,GPMALL购物商城后台管理系统', 'GPMALL后台管理系统 v1.0，是一款电商后台管理系统，适合中小型CMS后台系统。', '', '', '', '', 0, 'test login notice', 0, 'test all notice', '', '', 'http://istio.tech');
COMMIT;

-- ----------------------------
-- Table structure for tb_dict
-- ----------------------------
DROP TABLE IF EXISTS `tb_dict`;
CREATE TABLE `tb_dict` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dict` varchar(255) DEFAULT NULL,
  `type` int(1) DEFAULT NULL COMMENT '1扩展词 0停用词',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of tb_dict
-- ----------------------------
BEGIN;
INSERT INTO `tb_dict` VALUES (1, 'Mic', 1);
INSERT INTO `tb_dict` VALUES (2, 'GPMall', 1);
INSERT INTO `tb_dict` VALUES (4, 'test', 0);
COMMIT;

-- ----------------------------
-- Table structure for tb_express
-- ----------------------------
DROP TABLE IF EXISTS `tb_express`;
CREATE TABLE `tb_express` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '快递ID',
  `express_name` varchar(255) DEFAULT NULL COMMENT '商品描述',
  `sort_order` int(11) DEFAULT NULL COMMENT '排序',
  `created` datetime DEFAULT NULL COMMENT '创建时间',
  `updated` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='商品描述表';

-- ----------------------------
-- Records of tb_express
-- ----------------------------
BEGIN;
INSERT INTO `tb_express` VALUES (1, '京东快递', 1, '2018-05-31 11:45:10', NULL);
COMMIT;

-- ----------------------------
-- Table structure for tb_item
-- ----------------------------
DROP TABLE IF EXISTS `tb_item`;
CREATE TABLE `tb_item` (
  `id` bigint(20) NOT NULL COMMENT '商品id，同时也是商品编号',
  `title` varchar(100) DEFAULT NULL COMMENT '商品标题',
  `sell_point` varchar(100) DEFAULT NULL COMMENT '商品卖点',
  `price` decimal(10,2) DEFAULT '0.00' COMMENT '商品价格',
  `num` int(11) DEFAULT NULL COMMENT '库存数量',
  `limit_num` int(11) DEFAULT NULL COMMENT '售卖数量限制',
  `image` varchar(2000) DEFAULT NULL COMMENT '商品图片',
  `cid` bigint(11) DEFAULT NULL COMMENT '所属分类',
  `status` int(1) DEFAULT '1' COMMENT '商品状态 1正常 0下架',
  `created` datetime DEFAULT NULL COMMENT '创建时间',
  `updated` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `cid` (`cid`),
  KEY `status` (`status`),
  KEY `updated` (`updated`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商品表';

-- ----------------------------
-- Records of tb_item
-- ----------------------------
BEGIN;
INSERT INTO `tb_item` VALUES (100023501, 'Smartisan 双口 & 快充车载充电器', '铝合金机身、双口 & 快充、智能调节', 79.00, 100, 100, 'https://resource.smartisan.com/resource/d4480234a2f24b0ff5acd98288fd902d.jpg,https://resource.smartisan.com/resource/69ebf4ca620e6d5a1bb7cb54741e24d3.jpg,https://resource.smartisan.com/resource/214a422b7d250333bec4398d47eac601.jpg,https://resource.smartisan.com/resource/f512a3c4b97d204555f864d4aa17e7e9.jpg,https://resource.smartisan.com/resource/fc8a5d50ed260d9798cfba39ff5234d0.jpg', 221, 1, '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item` VALUES (100026701, 'Smartisan 原装快充充电器 18W', '18W 安全快充、支持主流 QC3.0, MTK PE+2.0 快充协议', 49.00, 100, 100, 'https://resource.smartisan.com/resource/dc53bd870ee64d2053ecc51750ece43a.jpg,https://resource.smartisan.com/resource/83ab82fa6d9637d29d6af79d912ee572.jpg,https://resource.smartisan.com/resource/47461596fad00d37cb7a032a03d79286.jpg,https://resource.smartisan.com/resource/f4f6346bea727862087b4761fc8b01d2.jpg,https://resource.smartisan.com/resource/0286c84dba36577f37591f1af2b97402.jpg', 215, 1, '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item` VALUES (100026801, 'Smartisan 耳机转接头', '即插即用、全面兼容', 19.00, 100, 100, 'https://resource.smartisan.com/resource/45312fb748d54aa2e58a8f4d637e9e65.jpg,https://resource.smartisan.com/resource/1dddddf6488ba89d592a37e9db93ffa2.jpg,https://resource.smartisan.com/resource/31b291594192c568b9fff9190a0d8f44.jpg,https://resource.smartisan.com/resource/561c002e74f6a5982dfaf3b4a44c9af4.jpg', 214, 1, '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item` VALUES (100036501, '畅呼吸除霾除甲醛高效复合滤芯', '精选双层防护材质，过滤更精细，去味更有效', 699.00, 100, 100, 'https://resource.smartisan.com/resource/00eee903962f17d75950397843117e6e.jpg,https://resource.smartisan.com/resource/7a1f7380f2f2851fe133bd84115c42fe.jpg,https://resource.smartisan.com/resource/e2cd33328fe96214c2bff3ef0652350a.jpg', 228, 1, '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item` VALUES (100039702, 'Smartisan 帆布鞋', '用于支付测试使用', 1.00, 100, 100, 'https://resource.smartisan.com/resource/578116bddf1d170c89e9af7ba5073fb6.jpg,https://resource.smartisan.com/resource/ebb01298315bf2ebdb6b21ee2c8e4237.jpg,https://resource.smartisan.com/resource/bd634d820859032b4c0f7a521eda486d.jpg,https://resource.smartisan.com/resource/51958a0a771f24e405f1b5de98108528.jpg,https://resource.smartisan.com/resource/e8791dd06c1e964d89436407f8827fe4.jpg', 236, 1, '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item` VALUES (100040501, '畅呼吸智能空气净化器 · 超级除甲醛版', '800CADR 超强空气净化能力，400CADR超强除甲醛能力，app远程操控，多种专业滤芯可供选择', 2999.00, 100, 100, 'https://resource.smartisan.com/resource/71432ad30288fb860a4389881069b874.png,https://resource.smartisan.com/resource/6ff92d05a3bfab4fad489ca04d3eea5a.png', 226, 1, '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item` VALUES (100042203, '坚果“电池形电池”移动电源', 'Type-C 接口、轻巧便携、多重电路保护', 49.00, 100, 100, 'https://resource.smartisan.com/resource/33954b3f6a2f1614c5482ef130af9cc8.jpg,https://resource.smartisan.com/resource/1910dba5f999debab84c97c55845c74d.jpg,https://resource.smartisan.com/resource/3e62068911a78fb4b7c4ac20520a5216.jpg,https://resource.smartisan.com/resource/0329e3f7d4fd64659b36a9f3726ccf37.jpg', 218, 1, '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item` VALUES (100042801, 'Smartisan 半入耳式耳机', '经典配色、专业调音、高品质麦克风', 59.00, 100, 100, 'https://resource.smartisan.com/resource/ce632bd67465027861707ec221b37c2d.jpg,https://resource.smartisan.com/resource/10525c4b21f039fc8ccb42cd1586f5cd.jpg,https://resource.smartisan.com/resource/d14645b66ff52c2e5958cd866a7d91e5.jpg,https://resource.smartisan.com/resource/7a4257950f953d6a7048d72de374530f.jpg,https://resource.smartisan.com/resource/dbe085a6f133b944e4e23bbb515c31ff.jpg', 217, 1, '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item` VALUES (100046401, '坚果 R1', '骁龙 845 处理器 · 光学防抖双摄像头 · 6.17 英寸压力感应屏幕 · 10W快速无线充电功能', 2999.00, 100, 100, 'https://resource.smartisan.com/resource/06c2253354096f5e9ebf0616f1af2086.png', 210, 1, '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item` VALUES (100047001, '坚果 QuickCharge 4+ 快速充电器', '全面兼容的 18W 快速充电', 1.00, 100, 100, 'https://resource.smartisan.com/resource/a668d1a5f41b04ece82d76ded1e94d3a.jpg,https://resource.smartisan.com/resource/c2375861762d557f65cf880b00161a41.jpg,https://resource.smartisan.com/resource/630dc5c945e78c0613d872cb83222b9e.jpg', 215, 1, '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item` VALUES (100047101, '坚果 Type-C To Type-C 数据线', 'TPE 环保材质，PTC 过温保护', 39.00, 100, 100, 'https://resource.smartisan.com/resource/8635cb91f2cdbbc5576e069c52b99412.jpg,https://resource.smartisan.com/resource/a9a02318cb09ab38562092a556d0dedc.jpg', 214, 1, '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item` VALUES (100051701, '坚果 Pro 2S', '双系统，无限屏，骁龙 ™ 710 处理器 · 前置 1600 万像素摄像头 · 6.01 英寸全高清全面屏 · AI 通话降噪 · 人脸解锁 + 指纹解锁 ', 1798.00, 100, 100, 'https://resource.smartisan.com/resource/b07b9765e272f866da6acda4ee107d88.png', 210, 1, '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item` VALUES (100052801, '坚果砖式蓝牙小音箱', '一款设计出色、音质出众的随身音箱', 149.00, 100, 100, 'https://resource.smartisan.com/resource/6e96ccea3bd56bdd2243eb20330cec30.jpg,https://resource.smartisan.com/resource/a99de61d502b2f29b4a6d847751cf478.jpg,https://resource.smartisan.com/resource/3f6594f3537db91a3a4d6196111429df.jpg,https://resource.smartisan.com/resource/9e45ff0ce5d60627f0b07b1df4c56ed6.jpg,https://resource.smartisan.com/resource/830389bcd0e66569acd5ce05a304a3ea.jpg', 223, 1, '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item` VALUES (100053001, '坚果彩虹数据线', '七彩配色随机发货，为生活增添一份小小惊喜', 19.00, 100, 100, 'https://resource.smartisan.com/resource/82aab62886740f165a3631ce6cffe895.jpg', 214, 1, '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item` VALUES (100053202, '地平线 8 号商务旅行箱', '为了野心和远方', 999.00, 100, 100, 'https://resource.smartisan.com/resource/d1dcca9144e8d13ffb33026148599d0a.png', 238, 1, '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item` VALUES (100053312, '地平线 8 号旅行箱', '简约设计、德国拜耳 PC 箱体', 299.00, 100, 100, 'https://resource.smartisan.com/resource/db4895e45ee6f3339037dbf7200e63f2.png', 238, 1, '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item` VALUES (100055301, 'Smartisan 快充移动电源 10000mAh', '10000mAh 双向快充、轻盈便携、高标准安全保护', 129.00, 100, 100, 'https://resource.smartisan.com/resource/b7105b0d819e610a9c38d7ca2a813e58.jpg,https://resource.smartisan.com/resource/e47687c8288b324fb997c5bd7b709e80.jpg,https://resource.smartisan.com/resource/c933dd520c84c32edd9f50f664ec53ff.jpg,https://resource.smartisan.com/resource/1ae4fda7154eb92196f78fe9efb0c25f.jpg,https://resource.smartisan.com/resource/422ec86b9924bd5e45d5caa3ba1eaf7d.jpg', 218, 1, '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item` VALUES (100055601, '各色DNA检测套装', '国内唯一聚焦于行为-基因关联性分析的基因检测解读', 499.00, 100, 100, 'https://resource.smartisan.com/resource/9bffe702b1f0aea221b1f18ddf886958.jpg,https://resource.smartisan.com/resource/30a1fce6a4280847eebf1b412fca39b0.jpg,https://resource.smartisan.com/resource/6681f43f88b9d867a0f33639cbeb47bf.jpg,https://resource.smartisan.com/resource/4fa597703a83cf326713faf2648744ac.jpg,https://resource.smartisan.com/resource/760637b38ba5ec5792e1e99c0d893462.jpg', 263, 1, '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item` VALUES (100057401, 'Smartisan T恤 迪特拉姆斯', '', 149.00, 100, 100, 'https://resource.smartisan.com/resource/005c65324724692f7c9ba2fc7738db13.png,https://resource.smartisan.com/resource/5068afef4f8866fae065d8c0d450e244.png,https://resource.smartisan.com/resource/a8dfe8f52dfb15c17e2e5c504c7ae2c6.png,https://resource.smartisan.com/resource/d6a6c06e5b51f0c18d8bfc45318163ea.png,https://resource.smartisan.com/resource/46724a81b037d1eca31d665c223b77a1.png', 231, 1, '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item` VALUES (100057501, 'Smartisan T恤 毕加索', '', 149.00, 100, 100, 'https://resource.smartisan.com/resource/e9cd634b62470713f6b9c5a6065f4a10.jpg,https://resource.smartisan.com/resource/2ea973de25dffab6373dbe5e343f76c8.jpg,https://resource.smartisan.com/resource/57c12d9b6788d005341fe4aefd209fab.jpg,https://resource.smartisan.com/resource/25fb00a88fe6ababcd580a2cf0a14032.jpg,https://resource.smartisan.com/resource/bab385bd6811378389a12d7b7254ed7e.jpg', 231, 1, '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item` VALUES (100057601, 'Smartisan T恤 皇帝的新装', '', 149.00, 100, 100, 'https://resource.smartisan.com/resource/d9586f7c5bb4578e3128de77a13e4d85.png,https://resource.smartisan.com/resource/07f77245d0f5f78f8ea580e181ec3dce.jpg,https://resource.smartisan.com/resource/0c9c397c8ac68a2ad327e1da8a5cb7d0.jpg,https://resource.smartisan.com/resource/154b35897ed3c1cb8dc1c7aae7b88f1f.jpg,https://resource.smartisan.com/resource/4a1686f2fde86e0aaac49c92395d4b32.jpg', 231, 1, '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item` VALUES (100057701, 'Smartisan T恤 丑小鸭', '', 149.00, 100, 100, 'https://resource.smartisan.com/resource/c23837ddfa3de0103be11bcbbb744066.png,https://resource.smartisan.com/resource/dad3d8d5ed151ad235ca9215815bc38b.png,https://resource.smartisan.com/resource/95f78a96e20b8e697e9df1c221d585c4.png,https://resource.smartisan.com/resource/33b0c45b3036d2a4267a05d192ccc45f.png,https://resource.smartisan.com/resource/b8bb658cf5cc22f23fb81a4c2ea028ac.png', 231, 1, '2019-07-29 14:37:02', '2019-07-29 14:37:02');
COMMIT;

-- ----------------------------
-- Table structure for tb_item_cat
-- ----------------------------
DROP TABLE IF EXISTS `tb_item_cat`;
CREATE TABLE `tb_item_cat` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '类目ID',
  `parent_id` bigint(20) DEFAULT NULL COMMENT '父分类ID=0时代表一级根分类',
  `name` varchar(50) DEFAULT NULL COMMENT '分类名称',
  `status` int(1) DEFAULT '1' COMMENT '状态 1启用 0禁用',
  `sort_order` int(4) DEFAULT NULL COMMENT '排列序号',
  `is_parent` tinyint(1) DEFAULT '1' COMMENT '是否为父分类 1为true 0为false',
  `icon` varchar(255) DEFAULT NULL COMMENT '图标',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `created` datetime DEFAULT NULL COMMENT '创建时间',
  `updated` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `parent_id` (`parent_id`,`status`) USING BTREE,
  KEY `sort_order` (`sort_order`)
) ENGINE=InnoDB AUTO_INCREMENT=299 DEFAULT CHARSET=utf8 COMMENT='商品类目';

-- ----------------------------
-- Records of tb_item_cat
-- ----------------------------
BEGIN;
INSERT INTO `tb_item_cat` VALUES (1, 1, '官方配件', 1, 0, 1, 'https://www.smartisan.com/category/185?type=shop', NULL, '2019-07-29 14:01:59', '2019-07-29 14:01:59');
INSERT INTO `tb_item_cat` VALUES (2, 1, '耳机', 1, 0, 0, '', 'shop', '2019-07-29 14:01:59', '2019-07-29 14:01:59');
INSERT INTO `tb_item_cat` VALUES (3, 1, '手机充电配件', 1, 1, 0, '', 'shop', '2019-07-29 14:01:59', '2019-07-29 14:01:59');
INSERT INTO `tb_item_cat` VALUES (4, 1, '自拍杆', 1, 2, 0, '', 'shop', '2019-07-29 14:01:59', '2019-07-29 14:01:59');
INSERT INTO `tb_item_cat` VALUES (5, 1, '音箱', 1, 3, 0, '', 'shop', '2019-07-29 14:01:59', '2019-07-29 14:01:59');
INSERT INTO `tb_item_cat` VALUES (6, 1, '车载配件', 1, 4, 0, '', 'shop', '2019-07-29 14:01:59', '2019-07-29 14:01:59');
INSERT INTO `tb_item_cat` VALUES (7, 1, '服饰箱包', 1, 1, 1, 'https://www.smartisan.com/category/157', NULL, '2019-07-29 14:01:59', '2019-07-29 14:01:59');
INSERT INTO `tb_item_cat` VALUES (8, 7, '服饰', 1, 0, 0, '', 'shop', '2019-07-29 14:01:59', '2019-07-29 14:01:59');
INSERT INTO `tb_item_cat` VALUES (9, 7, '鞋', 1, 1, 0, '', 'shop', '2019-07-29 14:01:59', '2019-07-29 14:01:59');
INSERT INTO `tb_item_cat` VALUES (10, 7, '箱包', 1, 2, 0, '', 'shop', '2019-07-29 14:01:59', '2019-07-29 14:01:59');
INSERT INTO `tb_item_cat` VALUES (11, 1, '畅呼吸', 1, 2, 1, 'https://www.smartisan.com/category/296?type=shop', NULL, '2019-07-29 14:01:59', '2019-07-29 14:01:59');
INSERT INTO `tb_item_cat` VALUES (12, 11, '生活电器', 1, 0, 0, '', 'shop', '2019-07-29 14:01:59', '2019-07-29 14:01:59');
INSERT INTO `tb_item_cat` VALUES (202, 8, 'T恤', 1, 0, 0, 'https://resource.smartisan.com/resource/d01dcb91b34b26cda7064a3c9bf655c4.png', '', '2019-07-29 14:01:59', '2019-07-29 14:01:59');
INSERT INTO `tb_item_cat` VALUES (204, 8, 'POLO衫', 1, 1, 0, 'https://resource.smartisan.com/resource/daa975651d6d700c0f886718c520ee19.jpg', '', '2019-07-29 14:01:59', '2019-07-29 14:01:59');
INSERT INTO `tb_item_cat` VALUES (206, 9, '帆布鞋', 1, 0, 0, 'https://resource.smartisan.com/resource/1db1a8bfee3623fded41c9115b5a5335.jpg', '', '2019-07-29 14:01:59', '2019-07-29 14:01:59');
INSERT INTO `tb_item_cat` VALUES (207, 10, '拉杆箱', 1, 0, 0, 'https://resource.smartisan.com/resource/9960e83a55544fbf7b046013a6f7f414.jpg', '', '2019-07-29 14:01:59', '2019-07-29 14:01:59');
INSERT INTO `tb_item_cat` VALUES (231, 3, '数据线', 1, 0, 0, 'https://resource.smartisan.com/resource/c79a73ffc6f8e782160d978f49f543dc.jpg', '', '2019-07-29 14:01:59', '2019-07-29 14:01:59');
INSERT INTO `tb_item_cat` VALUES (232, 3, '充电器', 1, 1, 0, 'https://resource.smartisan.com/resource/dc53bd870ee64d2053ecc51750ece43a.jpg', '', '2019-07-29 14:01:59', '2019-07-29 14:01:59');
INSERT INTO `tb_item_cat` VALUES (234, 2, '线控耳机', 1, 0, 0, 'https://resource.smartisan.com/resource/72e4c31e4e623f5c37c6489f6d91efc6.jpg', '', '2019-07-29 14:01:59', '2019-07-29 14:01:59');
INSERT INTO `tb_item_cat` VALUES (235, 3, '移动电源', 1, 2, 0, 'https://resource.smartisan.com/resource/afcec520933673b8e03a867e6502f6e0.jpg', '', '2019-07-29 14:01:59', '2019-07-29 14:01:59');
INSERT INTO `tb_item_cat` VALUES (236, 4, '自拍杆', 1, 0, 0, 'https://resource.smartisan.com/resource/b9e61c6d93464454fa2e382632e34cee.jpg', '', '2019-07-29 14:01:59', '2019-07-29 14:01:59');
INSERT INTO `tb_item_cat` VALUES (238, 6, '车载充电器', 1, 0, 0, 'https://resource.smartisan.com/resource/d4480234a2f24b0ff5acd98288fd902d.jpg', '', '2019-07-29 14:01:59', '2019-07-29 14:01:59');
INSERT INTO `tb_item_cat` VALUES (252, 5, '音箱', 1, 0, 0, 'https://resource.smartisan.com/resource/c44f0ab4da5591fc3d0f82b7ac0f4f65.jpg', '', '2019-07-29 14:01:59', '2019-07-29 14:01:59');
INSERT INTO `tb_item_cat` VALUES (292, 10, '包', 1, 1, 0, 'https://resource.smartisan.com/resource/cef4a5433eb95cbdf242d3c1bf5617f8.jpg', '', '2019-07-29 14:01:59', '2019-07-29 14:01:59');
INSERT INTO `tb_item_cat` VALUES (297, 12, '空气净化器', 1, 0, 0, 'https://resource.smartisan.com/resource/71432ad30288fb860a4389881069b874.png', '', '2019-07-29 14:01:59', '2019-07-29 14:01:59');
INSERT INTO `tb_item_cat` VALUES (298, 12, '生活电器配件', 1, 1, 0, 'https://resource.smartisan.com/resource/4d83d72c5ecc288e8d5ddd9d06b80f99.jpg', '', '2019-07-29 14:01:59', '2019-07-29 14:01:59');
COMMIT;

-- ----------------------------
-- Table structure for tb_item_desc
-- ----------------------------
DROP TABLE IF EXISTS `tb_item_desc`;
CREATE TABLE `tb_item_desc` (
  `item_id` bigint(20) NOT NULL COMMENT '商品ID',
  `item_desc` text COMMENT '商品描述',
  `created` datetime DEFAULT NULL COMMENT '创建时间',
  `updated` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商品描述表';

-- ----------------------------
-- Records of tb_item_desc
-- ----------------------------
BEGIN;
INSERT INTO `tb_item_desc` VALUES (100023501, '<img src=\"https://resource.smartisan.com/resource/1a4b3d159317fe26377b2db040aaa2dc.jpg\" style=\"width:880px;height:7966px\"/>', '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item_desc` VALUES (100026701, '<img src=\"https://resource.smartisan.com/resource/4a7b87fe01ec8339985702ee922d205a.jpg\" style=\"width:1220px;height:4526px\"/>', '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item_desc` VALUES (100026801, '<img src=\"https://resource.smartisan.com/resource/586f7bfcf88f14935918943bb0421c26.jpg\" style=\"width:1220px;height:4715px\"/>', '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item_desc` VALUES (100036501, '<img src=\"https://resource.smartisan.com/resource/55191eb9aeb1367eefcb6d946fdc0546.jpg\" style=\"width:1220px;height:9823px\"/>', '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item_desc` VALUES (100039702, '<img src=\"https://resource.smartisan.com/resource/88cfe3dc879813dd6f60e57405a58cc1.jpg\" style=\"width:1220px;height:8863px\"/>', '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item_desc` VALUES (100040501, '<img src=\"https://resource.smartisan.com/resource/cf9cd35a37fed165577358b5cf72df7a.jpg\" style=\"width:1220px;height:12671px\"/>', '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item_desc` VALUES (100042203, '<img src=\"https://resource.smartisan.com/resource/7d9e5c72d2af941602228d78c7b8904f.jpg\" style=\"width:1220px;height:8173px\"/>', '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item_desc` VALUES (100042801, '<img src=\"https://resource.smartisan.com/resource/234a5b125db07de264b5467d9ac15f1b.jpg\" style=\"width:1220px;height:8701px\"/>', '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item_desc` VALUES (100046401, '<img src=\"https://resource.smartisan.com/resource/79217e13f5f8d55cfb036edd93b2ce11.jpg\" style=\"width:1220px;height:24948px\"/>', '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item_desc` VALUES (100047001, '<img src=\"https://resource.smartisan.com/resource/a115f37d26c5ce4a99c0b5569cb736ab.jpg\" style=\"width:1220px;height:27384px\"/>', '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item_desc` VALUES (100047101, '<img src=\"https://resource.smartisan.com/resource/c6796a8fbe89a6ee92ede798be60c7ac.jpg\" style=\"width:1220px;height:5513px\"/>', '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item_desc` VALUES (100051701, '<img src=\"https://resource.smartisan.com/resource/a115f37d26c5ce4a99c0b5569cb736ab.jpg\" style=\"width:1220px;height:27384px\"/>', '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item_desc` VALUES (100052801, '<img src=\"https://resource.smartisan.com/resource/79217e13f5f8d55cfb036edd93b2ce11.jpg\" style=\"width:1220px;height:24948px\"/>', '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item_desc` VALUES (100053001, '<img src=\"https://resource.smartisan.com/resource/11e577bdce56fcf2048cd9a59a1498ad.jpg\" style=\"width:1220px;height:8475px\"/>', '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item_desc` VALUES (100053202, '<img src=\"https://resource.smartisan.com/resource/4285feb829a243a566cbe53af4b85438.jpg\" style=\"width:1220px;height:11689px\"/>', '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item_desc` VALUES (100053312, '<img src=\"https://resource.smartisan.com/resource/7d9803ef381540aa1c8097d3fc0680ea.png\" style=\"width:1220px;height:9166px\"/>', '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item_desc` VALUES (100055301, '<img src=\"https://resource.smartisan.com/resource/3ac96791a0b246a88ed8007223d5a2e2.jpg\" style=\"width:1220px;height:10486px\"/>', '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item_desc` VALUES (100055601, '<img src=\"https://resource.smartisan.com/resource/13bc92fefafd8583bcab13b4ff02b4a4.jpg\" style=\"width:1220px;height:28140px\"/>', '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item_desc` VALUES (100057401, '<img src=\"https://resource.smartisan.com/resource/6406be8c9066fd0fa6d4495f7aec9bfb.jpg\" style=\"width:1220px;height:14827px\"/>', '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item_desc` VALUES (100057501, '<img src=\"https://resource.smartisan.com/resource/6406be8c9066fd0fa6d4495f7aec9bfb.jpg\" style=\"width:1220px;height:14827px\"/>', '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item_desc` VALUES (100057601, '<img src=\"https://resource.smartisan.com/resource/6406be8c9066fd0fa6d4495f7aec9bfb.jpg\" style=\"width:1220px;height:14827px\"/>', '2019-07-29 14:37:02', '2019-07-29 14:37:02');
INSERT INTO `tb_item_desc` VALUES (100057701, '<img src=\"https://resource.smartisan.com/resource/6406be8c9066fd0fa6d4495f7aec9bfb.jpg\" style=\"width:1220px;height:14827px\"/>', '2019-07-29 14:37:02', '2019-07-29 14:37:02');
COMMIT;

-- ----------------------------
-- Table structure for tb_log
-- ----------------------------
DROP TABLE IF EXISTS `tb_log`;
CREATE TABLE `tb_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `request_type` varchar(255) DEFAULT NULL,
  `request_param` varchar(255) DEFAULT NULL,
  `user` varchar(255) DEFAULT NULL,
  `ip` varchar(255) DEFAULT NULL,
  `ip_info` varchar(255) DEFAULT NULL,
  `time` int(11) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for tb_member
-- ----------------------------
DROP TABLE IF EXISTS `tb_member`;
CREATE TABLE `tb_member` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL COMMENT '用户名',
  `password` varchar(32) NOT NULL COMMENT '密码，加密存储',
  `phone` varchar(20) DEFAULT NULL COMMENT '注册手机号',
  `email` varchar(50) DEFAULT NULL COMMENT '注册邮箱',
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  `sex` varchar(2) DEFAULT '',
  `address` varchar(255) DEFAULT NULL,
  `state` int(1) DEFAULT '0',
  `file` varchar(255) DEFAULT NULL COMMENT '头像',
  `description` varchar(500) DEFAULT NULL,
  `points` int(11) DEFAULT '0' COMMENT '积分',
  `balance` decimal(10,2) DEFAULT '0.00' COMMENT '余额',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`) USING BTREE,
  UNIQUE KEY `phone` (`phone`) USING BTREE,
  UNIQUE KEY `email` (`email`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
-- Records of tb_member
-- ----------------------------
BEGIN;
INSERT INTO `tb_member` VALUES (62, 'test', '098f6bcd4621d373cade4e832627b4f6', NULL, NULL, '2017-09-05 21:27:54', '2017-10-08 18:13:51', NULL, NULL, 1, 'http://ow2h3ee9w.bkt.clouddn.com/1507866636672.png', NULL, NULL, NULL);
INSERT INTO `tb_member` VALUES (66, 'mic', '4eea1e5de59fbc61cb3ab480dbbf6a5f', NULL, NULL, '2019-08-06 00:15:48', '2019-08-06 00:15:48', NULL, NULL, 1, NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for tb_order
-- ----------------------------
DROP TABLE IF EXISTS `tb_order`;
CREATE TABLE `tb_order` (
  `order_id` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '订单id',
  `payment` decimal(10,2) DEFAULT NULL COMMENT '实付金额',
  `payment_type` int(1) DEFAULT NULL COMMENT '支付类型 1在线支付 2货到付款',
  `post_fee` decimal(10,2) DEFAULT NULL COMMENT '邮费',
  `status` int(1) DEFAULT NULL COMMENT '状态 0未付款 1已付款 2未发货 3已发货 4交易成功 5交易关闭 6交易失败',
  `create_time` datetime DEFAULT NULL COMMENT '订单创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '订单更新时间',
  `payment_time` datetime DEFAULT NULL COMMENT '付款时间',
  `consign_time` datetime DEFAULT NULL COMMENT '发货时间',
  `end_time` datetime DEFAULT NULL COMMENT '交易完成时间',
  `close_time` datetime DEFAULT NULL COMMENT '交易关闭时间',
  `shipping_name` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '物流名称',
  `shipping_code` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '物流单号',
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户id',
  `buyer_message` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '买家留言',
  `buyer_nick` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '买家昵称',
  `buyer_comment` tinyint(1) DEFAULT NULL COMMENT '买家是否已经评价',
  PRIMARY KEY (`order_id`),
  KEY `create_time` (`create_time`),
  KEY `buyer_nick` (`buyer_nick`),
  KEY `status` (`status`),
  KEY `payment_type` (`payment_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of tb_order
-- ----------------------------
BEGIN;
INSERT INTO `tb_order` VALUES ('19080517070753127', 49.00, NULL, NULL, 0, '2019-08-05 04:07:08', '2019-08-05 04:07:08', NULL, NULL, NULL, NULL, NULL, NULL, 62, NULL, 'test', NULL);
INSERT INTO `tb_order` VALUES ('19080517141099516', 79.00, NULL, NULL, 0, '2019-08-05 04:14:11', '2019-08-05 04:14:11', NULL, NULL, NULL, NULL, NULL, NULL, 62, NULL, 'test', NULL);
INSERT INTO `tb_order` VALUES ('19080517173049838', 79.00, NULL, NULL, 0, '2019-08-05 04:17:31', '2019-08-05 04:17:31', NULL, NULL, NULL, NULL, NULL, NULL, 62, NULL, 'test', NULL);
INSERT INTO `tb_order` VALUES ('19080517194073300', 79.00, NULL, NULL, 0, '2019-08-05 04:19:41', '2019-08-05 04:19:41', NULL, NULL, NULL, NULL, NULL, NULL, 62, NULL, 'test', NULL);
INSERT INTO `tb_order` VALUES ('19080517204053817', 49.00, NULL, NULL, 0, '2019-08-05 04:20:41', '2019-08-05 04:20:41', NULL, NULL, NULL, NULL, NULL, NULL, 62, NULL, 'test', NULL);
INSERT INTO `tb_order` VALUES ('19080813030552616', 79.00, NULL, NULL, 0, '2019-08-08 00:03:06', '2019-08-08 00:03:06', NULL, NULL, NULL, NULL, NULL, NULL, 62, NULL, 'test', NULL);
INSERT INTO `tb_order` VALUES ('19080814120342501', 49.00, NULL, NULL, 0, '2019-08-08 01:12:03', '2019-08-08 01:12:03', NULL, NULL, NULL, NULL, NULL, NULL, 62, NULL, 'test', NULL);
INSERT INTO `tb_order` VALUES ('19080814122907793', 79.00, NULL, NULL, 0, '2019-08-08 01:12:29', '2019-08-08 01:12:29', NULL, NULL, NULL, NULL, NULL, NULL, 62, NULL, 'test', NULL);
INSERT INTO `tb_order` VALUES ('19080814125502099', 79.00, NULL, NULL, 0, '2019-08-08 01:12:55', '2019-08-08 01:12:55', NULL, NULL, NULL, NULL, NULL, NULL, 62, NULL, 'test', NULL);
INSERT INTO `tb_order` VALUES ('19080815140515317', 49.00, NULL, NULL, 0, '2019-08-08 02:14:05', '2019-08-08 02:14:05', NULL, NULL, NULL, NULL, NULL, NULL, 62, NULL, 'test', NULL);
INSERT INTO `tb_order` VALUES ('19080817174321892', 49.00, NULL, NULL, 0, '2019-08-08 04:17:43', '2019-08-08 04:17:43', NULL, NULL, NULL, NULL, NULL, NULL, 62, NULL, 'test', NULL);
INSERT INTO `tb_order` VALUES ('19080817175156866', 49.00, NULL, NULL, 0, '2019-08-08 04:17:52', '2019-08-08 04:17:52', NULL, NULL, NULL, NULL, NULL, NULL, 62, NULL, 'test', NULL);
INSERT INTO `tb_order` VALUES ('19080817203991587', 79.00, NULL, NULL, 0, '2019-08-08 04:20:40', '2019-08-08 04:20:40', NULL, NULL, NULL, NULL, NULL, NULL, 62, NULL, 'test', NULL);
INSERT INTO `tb_order` VALUES ('19080817204924310', 79.00, NULL, NULL, 0, '2019-08-08 04:20:49', '2019-08-08 04:20:49', NULL, NULL, NULL, NULL, NULL, NULL, 62, NULL, 'test', NULL);
INSERT INTO `tb_order` VALUES ('19080817263509780', 49.00, NULL, NULL, 0, '2019-08-08 04:26:35', '2019-08-08 04:26:35', NULL, NULL, NULL, NULL, NULL, NULL, 62, NULL, 'test', NULL);
INSERT INTO `tb_order` VALUES ('19080818515786502', 79.00, NULL, NULL, 0, '2019-08-08 05:51:58', '2019-08-08 05:51:58', NULL, NULL, NULL, NULL, NULL, NULL, 62, NULL, 'test', NULL);
INSERT INTO `tb_order` VALUES ('19080920162714464', 999.00, NULL, NULL, 0, '2019-08-09 12:16:27', '2019-08-09 12:16:27', NULL, NULL, NULL, NULL, NULL, NULL, 62, NULL, 'test', NULL);
INSERT INTO `tb_order` VALUES ('19080920181688179', 999.00, NULL, NULL, 0, '2019-08-09 12:18:17', '2019-08-09 12:18:17', NULL, NULL, NULL, NULL, NULL, NULL, 62, NULL, 'test', NULL);
INSERT INTO `tb_order` VALUES ('19080922231422902', 999.00, NULL, NULL, 0, '2019-08-09 14:23:14', '2019-08-09 14:23:14', NULL, NULL, NULL, NULL, NULL, NULL, 62, NULL, 'test', NULL);
COMMIT;

-- ----------------------------
-- Table structure for tb_order_item
-- ----------------------------
DROP TABLE IF EXISTS `tb_order_item`;
CREATE TABLE `tb_order_item` (
  `id` varchar(50) COLLATE utf8_bin NOT NULL,
  `item_id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '商品id',
  `order_id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '订单id',
  `num` int(10) DEFAULT NULL COMMENT '商品购买数量',
  `title` varchar(200) COLLATE utf8_bin DEFAULT NULL COMMENT '商品标题',
  `price` decimal(10,2) DEFAULT NULL COMMENT '商品单价',
  `total_fee` decimal(10,2) DEFAULT NULL COMMENT '商品总金额',
  `pic_path` varchar(1000) COLLATE utf8_bin DEFAULT NULL COMMENT '商品图片地址',
  PRIMARY KEY (`id`),
  KEY `item_id` (`item_id`),
  KEY `order_id` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of tb_order_item
-- ----------------------------
BEGIN;
INSERT INTO `tb_order_item` VALUES ('19080517070774058', '100026701', '19080517070753127', 1, 'Smartisan 原装快充充电器 18W', 49.00, 49.00, 'https://resource.smartisan.com/resource/dc53bd870ee64d2053ecc51750ece43a.jpg');
INSERT INTO `tb_order_item` VALUES ('19080517141100502', '100023501', '19080517141099516', 1, 'Smartisan 双口 & 快充车载充电器', 79.00, 79.00, 'https://resource.smartisan.com/resource/d4480234a2f24b0ff5acd98288fd902d.jpg');
INSERT INTO `tb_order_item` VALUES ('19080517173050619', '100023501', '19080517173049838', 1, 'Smartisan 双口 & 快充车载充电器', 79.00, 79.00, 'https://resource.smartisan.com/resource/d4480234a2f24b0ff5acd98288fd902d.jpg');
INSERT INTO `tb_order_item` VALUES ('19080517194074018', '100023501', '19080517194073300', 1, 'Smartisan 双口 & 快充车载充电器', 79.00, 79.00, 'https://resource.smartisan.com/resource/d4480234a2f24b0ff5acd98288fd902d.jpg');
INSERT INTO `tb_order_item` VALUES ('19080517204054596', '100026701', '19080517204053817', 1, 'Smartisan 原装快充充电器 18W', 49.00, 49.00, 'https://resource.smartisan.com/resource/dc53bd870ee64d2053ecc51750ece43a.jpg');
INSERT INTO `tb_order_item` VALUES ('19080813030571714', '100023501', '19080813030552616', 1, 'Smartisan 双口 & 快充车载充电器', 79.00, 79.00, 'https://resource.smartisan.com/resource/d4480234a2f24b0ff5acd98288fd902d.jpg');
INSERT INTO `tb_order_item` VALUES ('19080814120343487', '100026701', '19080814120342501', 1, 'Smartisan 原装快充充电器 18W', 49.00, 49.00, 'https://resource.smartisan.com/resource/dc53bd870ee64d2053ecc51750ece43a.jpg');
INSERT INTO `tb_order_item` VALUES ('19080814122908440', '100023501', '19080814122907793', 1, 'Smartisan 双口 & 快充车载充电器', 79.00, 79.00, 'https://resource.smartisan.com/resource/d4480234a2f24b0ff5acd98288fd902d.jpg');
INSERT INTO `tb_order_item` VALUES ('19080814125502597', '100023501', '19080814125502099', 1, 'Smartisan 双口 & 快充车载充电器', 79.00, 79.00, 'https://resource.smartisan.com/resource/d4480234a2f24b0ff5acd98288fd902d.jpg');
INSERT INTO `tb_order_item` VALUES ('19080815140516384', '100026701', '19080815140515317', 1, 'Smartisan 原装快充充电器 18W', 49.00, 49.00, 'https://resource.smartisan.com/resource/dc53bd870ee64d2053ecc51750ece43a.jpg');
INSERT INTO `tb_order_item` VALUES ('19080817174322546', '100026701', '19080817174321892', 1, 'Smartisan 原装快充充电器 18W', 49.00, 49.00, 'https://resource.smartisan.com/resource/dc53bd870ee64d2053ecc51750ece43a.jpg');
INSERT INTO `tb_order_item` VALUES ('19080817175157456', '100026701', '19080817175156866', 1, 'Smartisan 原装快充充电器 18W', 49.00, 49.00, 'https://resource.smartisan.com/resource/dc53bd870ee64d2053ecc51750ece43a.jpg');
INSERT INTO `tb_order_item` VALUES ('19080817203992179', '100023501', '19080817203991587', 1, 'Smartisan 双口 & 快充车载充电器', 79.00, 79.00, 'https://resource.smartisan.com/resource/d4480234a2f24b0ff5acd98288fd902d.jpg');
INSERT INTO `tb_order_item` VALUES ('19080817204924909', '100023501', '19080817204924310', 1, 'Smartisan 双口 & 快充车载充电器', 79.00, 79.00, 'https://resource.smartisan.com/resource/d4480234a2f24b0ff5acd98288fd902d.jpg');
INSERT INTO `tb_order_item` VALUES ('19080817263510494', '100026701', '19080817263509780', 1, 'Smartisan 原装快充充电器 18W', 49.00, 49.00, 'https://resource.smartisan.com/resource/dc53bd870ee64d2053ecc51750ece43a.jpg');
INSERT INTO `tb_order_item` VALUES ('19080818515787348', '100023501', '19080818515786502', 1, 'Smartisan 双口 & 快充车载充电器', 79.00, 79.00, 'https://resource.smartisan.com/resource/d4480234a2f24b0ff5acd98288fd902d.jpg');
INSERT INTO `tb_order_item` VALUES ('19080920162727714', '100053202', '19080920162714464', 1, '地平线 8 号商务旅行箱', 999.00, 999.00, 'https://resource.smartisan.com/resource/d1dcca9144e8d13ffb33026148599d0a.png');
INSERT INTO `tb_order_item` VALUES ('19080920181690886', '100053202', '19080920181688179', 1, '地平线 8 号商务旅行箱', 999.00, 999.00, 'https://resource.smartisan.com/resource/d1dcca9144e8d13ffb33026148599d0a.png');
INSERT INTO `tb_order_item` VALUES ('19080922231442537', '100053202', '19080922231422902', 1, '地平线 8 号商务旅行箱', 999.00, 999.00, 'https://resource.smartisan.com/resource/d1dcca9144e8d13ffb33026148599d0a.png');
COMMIT;

-- ----------------------------
-- Table structure for tb_order_shipping
-- ----------------------------
DROP TABLE IF EXISTS `tb_order_shipping`;
CREATE TABLE `tb_order_shipping` (
  `order_id` varchar(50) NOT NULL COMMENT '订单ID',
  `receiver_name` varchar(20) DEFAULT NULL COMMENT '收货人全名',
  `receiver_phone` varchar(20) DEFAULT NULL COMMENT '固定电话',
  `receiver_mobile` varchar(30) DEFAULT NULL COMMENT '移动电话',
  `receiver_state` varchar(10) DEFAULT NULL COMMENT '省份',
  `receiver_city` varchar(10) DEFAULT NULL COMMENT '城市',
  `receiver_district` varchar(20) DEFAULT NULL COMMENT '区/县',
  `receiver_address` varchar(200) DEFAULT NULL COMMENT '收货地址，如：xx路xx号',
  `receiver_zip` varchar(6) DEFAULT NULL COMMENT '邮政编码,如：310001',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_order_shipping
-- ----------------------------
BEGIN;
INSERT INTO `tb_order_shipping` VALUES ('19080517070753127', 'Mic', '18073804421', NULL, NULL, NULL, NULL, '湖南省长沙市麓谷企业广场A3栋3单元407', NULL, '2019-08-05 04:07:08', '2019-08-05 04:07:08');
INSERT INTO `tb_order_shipping` VALUES ('19080517141099516', 'Mic', '18073804421', NULL, NULL, NULL, NULL, '湖南省长沙市麓谷企业广场A3栋3单元407', NULL, '2019-08-05 04:14:11', '2019-08-05 04:14:11');
INSERT INTO `tb_order_shipping` VALUES ('19080517173049838', 'Mic', '18073804421', NULL, NULL, NULL, NULL, '湖南省长沙市麓谷企业广场A3栋3单元407', NULL, '2019-08-05 04:17:31', '2019-08-05 04:17:31');
INSERT INTO `tb_order_shipping` VALUES ('19080517194073300', 'Mic', '18073804421', NULL, NULL, NULL, NULL, '湖南省长沙市麓谷企业广场A3栋3单元407', NULL, '2019-08-05 04:19:41', '2019-08-05 04:19:41');
INSERT INTO `tb_order_shipping` VALUES ('19080517204053817', 'Mic', '18073804421', NULL, NULL, NULL, NULL, '湖南省长沙市麓谷企业广场A3栋3单元407', NULL, '2019-08-05 04:20:41', '2019-08-05 04:20:41');
INSERT INTO `tb_order_shipping` VALUES ('19080813030552616', 'Mic', '18073804421', NULL, NULL, NULL, NULL, '湖南省长沙市麓谷企业广场A3栋3单元407', NULL, '2019-08-08 00:03:06', '2019-08-08 00:03:06');
INSERT INTO `tb_order_shipping` VALUES ('19080814120342501', 'Mic', '18073804421', NULL, NULL, NULL, NULL, '湖南省长沙市麓谷企业广场A3栋3单元407', NULL, '2019-08-08 01:12:03', '2019-08-08 01:12:03');
INSERT INTO `tb_order_shipping` VALUES ('19080814122907793', 'Mic', '18073804421', NULL, NULL, NULL, NULL, '湖南省长沙市麓谷企业广场A3栋3单元407', NULL, '2019-08-08 01:12:29', '2019-08-08 01:12:29');
INSERT INTO `tb_order_shipping` VALUES ('19080814125502099', 'Mic', '18073804421', NULL, NULL, NULL, NULL, '湖南省长沙市麓谷企业广场A3栋3单元407', NULL, '2019-08-08 01:12:55', '2019-08-08 01:12:55');
INSERT INTO `tb_order_shipping` VALUES ('19080815140515317', 'Mic', '18073804421', NULL, NULL, NULL, NULL, '湖南省长沙市麓谷企业广场A3栋3单元407', NULL, '2019-08-08 02:14:05', '2019-08-08 02:14:05');
INSERT INTO `tb_order_shipping` VALUES ('19080817174321892', 'Mic', '18073804421', NULL, NULL, NULL, NULL, '湖南省长沙市麓谷企业广场A3栋3单元407', NULL, '2019-08-08 04:17:43', '2019-08-08 04:17:43');
INSERT INTO `tb_order_shipping` VALUES ('19080817175156866', 'Mic', '18073804421', NULL, NULL, NULL, NULL, '湖南省长沙市麓谷企业广场A3栋3单元407', NULL, '2019-08-08 04:17:52', '2019-08-08 04:17:52');
INSERT INTO `tb_order_shipping` VALUES ('19080817203991587', 'Mic', '18073804421', NULL, NULL, NULL, NULL, '湖南省长沙市麓谷企业广场A3栋3单元407', NULL, '2019-08-08 04:20:40', '2019-08-08 04:20:40');
INSERT INTO `tb_order_shipping` VALUES ('19080817204924310', 'Mic', '18073804421', NULL, NULL, NULL, NULL, '湖南省长沙市麓谷企业广场A3栋3单元407', NULL, '2019-08-08 04:20:49', '2019-08-08 04:20:49');
INSERT INTO `tb_order_shipping` VALUES ('19080817263509780', 'Mic', '18073804421', NULL, NULL, NULL, NULL, '湖南省长沙市麓谷企业广场A3栋3单元407', NULL, '2019-08-08 04:26:35', '2019-08-08 04:26:35');
INSERT INTO `tb_order_shipping` VALUES ('19080818515786502', 'Mic', '18073804421', NULL, NULL, NULL, NULL, '湖南省长沙市麓谷企业广场A3栋3单元407', NULL, '2019-08-08 05:51:58', '2019-08-08 05:51:58');
INSERT INTO `tb_order_shipping` VALUES ('19080920162714464', 'Mic', '18073804421', NULL, NULL, NULL, NULL, '湖南省长沙市麓谷企业广场A3栋3单元407', NULL, '2019-08-09 12:16:27', '2019-08-09 12:16:27');
INSERT INTO `tb_order_shipping` VALUES ('19080920181688179', 'Mic', '18073804421', NULL, NULL, NULL, NULL, '湖南省长沙市麓谷企业广场A3栋3单元407', NULL, '2019-08-09 12:18:17', '2019-08-09 12:18:17');
INSERT INTO `tb_order_shipping` VALUES ('19080922231422902', 'Mic', '18073804421', NULL, NULL, NULL, NULL, '湖南省长沙市麓谷企业广场A3栋3单元407', NULL, '2019-08-09 14:23:14', '2019-08-09 14:23:14');
COMMIT;

-- ----------------------------
-- Table structure for tb_panel
-- ----------------------------
DROP TABLE IF EXISTS `tb_panel`;
CREATE TABLE `tb_panel` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '类目ID',
  `name` varchar(50) DEFAULT NULL COMMENT '板块名称',
  `type` int(1) DEFAULT NULL COMMENT '类型 0轮播图 1板块种类一 2板块种类二 3板块种类三 ',
  `sort_order` int(4) DEFAULT NULL COMMENT '排列序号',
  `position` int(1) DEFAULT NULL COMMENT '所属位置 0首页 1商品推荐 2我要捐赠',
  `limit_num` int(4) DEFAULT NULL COMMENT '板块限制商品数量',
  `status` int(1) DEFAULT '1' COMMENT '状态',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `created` datetime DEFAULT NULL COMMENT '创建时间',
  `updated` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `parent_id` (`status`) USING BTREE,
  KEY `sort_order` (`sort_order`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='内容分类';

-- ----------------------------
-- Records of tb_panel
-- ----------------------------
BEGIN;
INSERT INTO `tb_panel` VALUES (1, '热门商品', 2, 1, 0, 3, 1, '', '2018-04-18 23:49:13', '2018-04-15 19:05:16');
INSERT INTO `tb_panel` VALUES (2, '服饰箱包', 3, 3, 0, 8, 1, '', NULL, '2018-04-19 11:20:59');
INSERT INTO `tb_panel` VALUES (3, '官方精选配件', 3, 2, 0, 7, 1, '', '2018-04-18 23:49:19', '2018-04-17 18:54:15');
INSERT INTO `tb_panel` VALUES (6, '热门推荐', 2, 6, 1, 2, 1, '热门推荐', '2019-07-29 23:58:19', '2019-07-29 23:58:23');
INSERT INTO `tb_panel` VALUES (7, '轮播图', 0, 0, 0, 5, 1, 'banner板块', '2018-04-15 12:33:07', '2018-04-15 12:33:07');
INSERT INTO `tb_panel` VALUES (8, '活动版块', 1, 5, 0, 4, 1, '', '2018-04-15 19:05:00', '2018-04-15 19:05:00');
INSERT INTO `tb_panel` VALUES (10, '坚果手机及配件', 3, 4, 0, 7, 1, NULL, '2018-04-18 23:50:32', '2018-04-18 23:50:35');
COMMIT;

-- ----------------------------
-- Table structure for tb_panel_content
-- ----------------------------
DROP TABLE IF EXISTS `tb_panel_content`;
CREATE TABLE `tb_panel_content` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `panel_id` int(11) NOT NULL COMMENT '所属板块id',
  `type` int(1) DEFAULT NULL COMMENT '类型 0关联商品 1其他链接',
  `product_id` bigint(20) DEFAULT NULL COMMENT '关联商品id',
  `sort_order` int(4) DEFAULT NULL,
  `full_url` varchar(500) DEFAULT NULL COMMENT '其他链接',
  `pic_url` varchar(500) DEFAULT NULL,
  `pic_url2` varchar(500) DEFAULT NULL COMMENT '3d轮播图备用',
  `pic_url3` varchar(500) DEFAULT NULL COMMENT '3d轮播图备用',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `category_id` (`panel_id`),
  KEY `updated` (`updated`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_panel_content
-- ----------------------------
BEGIN;
INSERT INTO `tb_panel_content` VALUES (2, 3, 0, 100026701, 1, '', 'https://resource.smartisan.com/resource/dc53bd870ee64d2053ecc51750ece43a.jpg?x-oss-process=image/resize,w_216/format,webp', NULL, NULL, '2017-09-23 00:03:02', '2018-04-20 00:23:40');
INSERT INTO `tb_panel_content` VALUES (7, 3, 0, 100023501, 2, '', 'https://resource.smartisan.com/resource/d4480234a2f24b0ff5acd98288fd902d.jpg?x-oss-process=image/resize,w_216/format,webp', NULL, NULL, '2017-09-23 22:58:11', '2018-04-20 00:14:29');
INSERT INTO `tb_panel_content` VALUES (8, 2, 0, 100053202, 1, '', 'https://resource.smartisan.com/resource/db4895e45ee6f3339037dbf7200e63f2.png?x-oss-process=image/resize,w_216/format,webp', NULL, NULL, '2017-09-25 17:03:48', '2018-04-19 23:23:26');
INSERT INTO `tb_panel_content` VALUES (9, 2, 0, 100053312, 2, '', 'https://resource.smartisan.com/resource/d1dcca9144e8d13ffb33026148599d0a.png?x-oss-process=image/resize,w_216/format,webp', NULL, NULL, '2017-09-25 17:04:35', '2018-04-20 10:48:17');
INSERT INTO `tb_panel_content` VALUES (14, 2, 0, 100057401, 3, '', 'https://resource.smartisan.com/resource/c892f825c80767c2bef15081352d2aa4.png?x-oss-process=image/resize,w_216/format,webp', NULL, NULL, '2017-10-22 22:14:01', '2018-04-20 10:48:29');
INSERT INTO `tb_panel_content` VALUES (15, 2, 0, 100057501, 4, '', 'https://resource.smartisan.com/resource/005c65324724692f7c9ba2fc7738db13.png?x-oss-process=image/resize,w_216/format,webp', NULL, NULL, '2017-10-22 22:14:52', '2018-04-20 10:48:43');
INSERT INTO `tb_panel_content` VALUES (16, 2, 0, 100057601, 5, '', 'https://resource.smartisan.com/resource/d9586f7c5bb4578e3128de77a13e4d85.png?x-oss-process=image/resize,w_216/format,webp', NULL, NULL, '2017-10-22 22:15:51', '2018-04-20 10:49:02');
INSERT INTO `tb_panel_content` VALUES (17, 2, 0, 100057701, 6, '', 'https://resource.smartisan.com/resource/e9cd634b62470713f6b9c5a6065f4a10.jpg?x-oss-process=image/resize,w_216/format,webp', NULL, NULL, '2017-10-22 22:17:01', '2018-04-20 10:49:17');
INSERT INTO `tb_panel_content` VALUES (18, 3, 0, 100042801, 3, NULL, 'https://resource.smartisan.com/resource/30ac0a1ab02999667f1362c501447e58.jpg?x-oss-process=image/resize,w_216/format,webp', NULL, NULL, '2017-10-22 22:22:52', '2017-10-22 22:22:52');
INSERT INTO `tb_panel_content` VALUES (19, 3, 0, 100053001, 4, '', 'https://resource.smartisan.com/resource/82aab62886740f165a3631ce6cffe895.jpg?x-oss-process=image/resize,w_216/format,webp', NULL, NULL, '2017-10-22 22:23:35', '2018-04-20 11:25:38');
INSERT INTO `tb_panel_content` VALUES (20, 3, 0, 100042203, 5, '', 'https://resource.smartisan.com/resource/f5a36dfc37d52a643683f4a21247f3ff.jpg?x-oss-process=image/resize,w_216/format,webp', NULL, NULL, '2017-10-22 22:24:54', '2018-04-20 00:15:03');
INSERT INTO `tb_panel_content` VALUES (21, 3, 0, 100055301, 6, '', 'https://resource.smartisan.com/resource/f319b26eb69e8ba351423abfad347eae.jpg?x-oss-process=image/resize,w_216/format,webp', NULL, NULL, '2017-10-22 22:25:28', '2018-04-20 00:24:11');
INSERT INTO `tb_panel_content` VALUES (22, 1, 0, 100039702, 1, NULL, 'https://resource.smartisan.com/resource/2f9a0f5f3dedf0ed813622003f1b287b.jpg?x-oss-process=image/resize,w_216/format,webp', NULL, NULL, '2017-10-22 22:26:31', '2017-10-22 22:26:31');
INSERT INTO `tb_panel_content` VALUES (23, 1, 0, 100047001, 2, '', 'https://resource.smartisan.com/resource/a668d1a5f41b04ece82d76ded1e94d3a.jpg?x-oss-process=image/resize,w_216/format,webp', NULL, NULL, '2017-10-22 22:26:40', '2018-04-17 20:59:35');
INSERT INTO `tb_panel_content` VALUES (25, 8, 7, NULL, 1, 'https://gper.club/answers/7e7e7f7ff4g56gc9g6e', 'https://resource.smartisan.com/resource/6/610400xinpinpeijian.jpg', NULL, NULL, '2018-04-15 19:07:43', '2018-04-19 23:20:34');
INSERT INTO `tb_panel_content` VALUES (26, 8, 7, NULL, 2, 'https://www/gupaoedu.com', 'https://resource.smartisan.com/resource/6/610400yijiuhuanxin.jpg', NULL, NULL, '2018-04-15 19:08:00', '2018-04-19 23:20:48');
INSERT INTO `tb_panel_content` VALUES (27, 8, 7, NULL, 3, 'https://ke.qq.com/course/185189?taid=1885512117965669', 'https://resource.smartisan.com/resource/4/489673079577637073.png', NULL, NULL, '2018-04-15 19:08:24', '2018-04-19 23:21:01');
INSERT INTO `tb_panel_content` VALUES (28, 8, 7, NULL, 4, 'https://www.gupaoedu.com/course-java.html', 'https://resource.smartisan.com/resource/fe6ab43348a43152b4001b4454d206ac.jpg', NULL, NULL, '2018-04-15 19:08:58', '2018-04-19 23:21:13');
INSERT INTO `tb_panel_content` VALUES (29, 2, 2, 100053312, 0, '', 'https://resource.smartisan.com/resource/3e931e9d0d270dae19b7fe9695551b4c.png?x-oss-process=image/resize,w_609/format,jpg/quality,Q_100', NULL, NULL, '2018-04-15 20:14:35', '2018-04-20 11:41:27');
INSERT INTO `tb_panel_content` VALUES (30, 3, 2, 100052801, 0, '', 'https://resource.smartisan.com/resource/fde550fa598718a4d9661c0f1557ce55.png?x-oss-process=image/resize,w_609/format,jpg/quality,Q_100', NULL, NULL, '2018-04-15 20:15:18', '2018-04-20 11:18:03');
INSERT INTO `tb_panel_content` VALUES (32, 7, 0, 100053312, 1, '', 'https://resource.smartisan.com/resource/52427d5ed690525b545d296159ffc63b.png?x-oss-process=image/format,jpg/quality,Q_100', '', '', '2018-04-17 20:41:02', '2018-04-17 20:58:41');
INSERT INTO `tb_panel_content` VALUES (33, 7, 0, 100057401, 2, '', 'https://resource.smartisan.com/resource/l/lou1.png?x-oss-process=image/format,jpg/quality,Q_100', '', '', '2018-04-17 21:08:22', '2018-04-20 10:47:19');
INSERT INTO `tb_panel_content` VALUES (34, 7, 0, 100040501, 3, NULL, 'https://resource.smartisan.com/resource/a9b9b5083118db99a58fe65afb6167e3.png?x-oss-process=image/format,jpg/quality,Q_100', '', '', '2018-04-17 21:08:30', '2018-04-17 21:08:32');
INSERT INTO `tb_panel_content` VALUES (40, 10, 3, 100046401, 0, '', 'https://resource.smartisan.com/resource/896f85d0ee0669ee1fdd8efc19bffc57.jpg?x-oss-process=image/resize,w_609/format,jpg/quality,Q_100', NULL, NULL, '2018-04-19 00:02:53', '2018-04-20 11:15:59');
INSERT INTO `tb_panel_content` VALUES (41, 10, 0, 100051701, 1, '', 'https://resource.smartisan.com/resource/b07b9765e272f866da6acda4ee107d88.png?x-oss-process=image/resize,w_216/format,webp', NULL, NULL, '2018-04-19 00:02:56', '2018-04-20 00:24:36');
INSERT INTO `tb_panel_content` VALUES (42, 10, 0, 100046401, 2, '', 'https://resource.smartisan.com/resource/17f254e6f809355d8fe66260ccb48fb0.png?x-oss-process=image/resize,w_216/format,webp', NULL, NULL, '2018-04-19 00:03:00', '2018-04-20 00:25:01');
INSERT INTO `tb_panel_content` VALUES (43, 10, 0, 100053001, 3, '', 'https://resource.smartisan.com/resource/82aab62886740f165a3631ce6cffe895.jpg?x-oss-process=image/resize,w_216/format,webp', NULL, NULL, '2018-04-19 00:03:04', '2018-04-20 00:25:17');
INSERT INTO `tb_panel_content` VALUES (44, 10, 0, 100047101, 4, '', 'https://resource.smartisan.com/resource/8635cb91f2cdbbc5576e069c52b99412.jpg?x-oss-process=image/resize,w_216/format,webp', NULL, NULL, '2018-04-19 00:03:10', '2018-04-20 10:55:52');
INSERT INTO `tb_panel_content` VALUES (45, 10, 0, 100026801, 5, '', 'https://resource.smartisan.com/resource/45312fb748d54aa2e58a8f4d637e9e65.jpg?x-oss-process=image/resize,w_216/format,webp', NULL, NULL, '2018-04-19 00:03:15', '2018-04-20 10:54:56');
INSERT INTO `tb_panel_content` VALUES (46, 10, 0, 100042801, 6, '', 'https://resource.smartisan.com/resource/8a875418797690e26b665cc0d86dffc7.jpg?x-oss-process=image/resize,w_216/format,webp', NULL, NULL, '2018-04-19 00:03:20', '2018-04-20 10:55:03');
INSERT INTO `tb_panel_content` VALUES (47, 6, 0, 100046401, 1, '', 'https://resource.smartisan.com/resource/06c2253354096f5e9ebf0616f1af2086.png', NULL, NULL, '2018-04-19 11:15:35', '2018-04-19 11:15:35');
INSERT INTO `tb_panel_content` VALUES (48, 6, 0, 100051701, 2, NULL, 'https://resource.smartisan.com/resource/b07b9765e272f866da6acda4ee107d88.png', NULL, NULL, '2018-04-19 11:18:16', '2018-04-19 11:18:18');
INSERT INTO `tb_panel_content` VALUES (55, 0, 1, NULL, 1, '', '手机', NULL, NULL, '2018-07-27 20:48:21', '2018-07-27 22:32:51');
INSERT INTO `tb_panel_content` VALUES (58, 0, 1, NULL, 2, '', '官方配件', NULL, NULL, '2018-07-27 20:50:07', '2018-07-27 22:25:18');
INSERT INTO `tb_panel_content` VALUES (59, 0, 0, NULL, 3, '', '服饰箱包', NULL, NULL, '2018-07-27 22:25:44', '2018-07-27 22:26:54');
INSERT INTO `tb_panel_content` VALUES (60, 0, 0, NULL, 4, '', '畅呼吸', NULL, NULL, '2018-07-27 22:26:03', '2018-07-27 22:26:50');
INSERT INTO `tb_panel_content` VALUES (61, 0, 0, NULL, 5, '', '服务', NULL, NULL, '2018-07-27 22:26:21', '2018-07-27 22:26:47');
COMMIT;

-- ----------------------------
-- Table structure for tb_payment
-- ----------------------------
DROP TABLE IF EXISTS `tb_payment`;
CREATE TABLE `tb_payment` (
  `id` varchar(50) NOT NULL,
  `status` varchar(20) NOT NULL COMMENT '支付状态',
  `order_id` varchar(50) NOT NULL COMMENT '订单id',
  `product_name` varchar(80) DEFAULT NULL COMMENT '产品名称',
  `pay_no` varchar(80) DEFAULT NULL COMMENT '支付流水号',
  `payer_uid` int(20) NOT NULL COMMENT '付款人id',
  `payer_name` varchar(50) DEFAULT NULL COMMENT '付款人姓名',
  `payer_amount` decimal(10,2) NOT NULL COMMENT '付款方支付金额',
  `order_amount` decimal(10,2) NOT NULL COMMENT '订单金额',
  `pay_way` varchar(10) NOT NULL COMMENT '支付方式',
  `pay_success_time` datetime DEFAULT NULL COMMENT '支付成功时间',
  `complete_time` datetime DEFAULT NULL COMMENT '支付完成时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of tb_payment
-- ----------------------------
BEGIN;
INSERT INTO `tb_payment` VALUES ('3151c568-1188-48f9-be08-35ea76c1d5f6', '1', '19080920181688179', '地平线 8 号商务旅行箱', NULL, 62, '', 1.00, 1.00, 'alipay', NULL, NULL, '', '2019-08-09 13:17:05', '2019-08-09 13:17:05');
INSERT INTO `tb_payment` VALUES ('aba7e42f-6df2-418c-ac0a-cd9010eb17f0', '1', '19080920181688179', '地平线 8 号商务旅行箱', NULL, 62, '', 1.00, 1.00, 'alipay', NULL, NULL, '', '2019-08-09 13:13:31', '2019-08-09 13:13:31');
INSERT INTO `tb_payment` VALUES ('e5c20deb-feec-4892-971a-56a4750509d6', '1', '19080920181688179', '地平线 8 号商务旅行箱', NULL, 62, '', 1.00, 1.00, 'alipay', NULL, NULL, '', '2019-08-09 13:20:22', '2019-08-09 13:20:22');
INSERT INTO `tb_payment` VALUES ('f5aff18e-0d11-4c80-bdc9-f6b329c188db', '1', '19080922231422902', '地平线 8 号商务旅行箱', NULL, 62, '', 1.00, 1.00, 'alipay', NULL, NULL, '', '2019-08-09 14:23:39', '2019-08-09 14:23:39');
COMMIT;

-- ----------------------------
-- Table structure for tb_permission
-- ----------------------------
DROP TABLE IF EXISTS `tb_permission`;
CREATE TABLE `tb_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `permission` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_permission
-- ----------------------------
BEGIN;
INSERT INTO `tb_permission` VALUES (17, '添加栏目内容', '/content/add');
INSERT INTO `tb_permission` VALUES (18, '删除栏目内容', '/content/del/*');
INSERT INTO `tb_permission` VALUES (19, '编辑栏目内容', '/content/update');
INSERT INTO `tb_permission` VALUES (20, 'webupload图片上传', '/image/imageUpload');
INSERT INTO `tb_permission` VALUES (21, 'kindeditor图片上传', '/kindeditor/imageUpload');
INSERT INTO `tb_permission` VALUES (23, '商品分类编辑', '/item/cat/update');
INSERT INTO `tb_permission` VALUES (24, '商品分类添加', '/item/cat/add');
INSERT INTO `tb_permission` VALUES (25, '商品分类删除', '/item/cat/del/*');
INSERT INTO `tb_permission` VALUES (27, '商品添加', '/item/add');
INSERT INTO `tb_permission` VALUES (28, '商品删除', '/item/del/*');
INSERT INTO `tb_permission` VALUES (29, '启用商品', '/item/start/*');
INSERT INTO `tb_permission` VALUES (30, '停用商品', '/item/stop/*');
INSERT INTO `tb_permission` VALUES (31, '编辑商品', '/item/update/*');
INSERT INTO `tb_permission` VALUES (33, '会员添加', '/member/add');
INSERT INTO `tb_permission` VALUES (34, '修改会员密码', '/member/changePass/*');
INSERT INTO `tb_permission` VALUES (35, '会员删除', '/member/del/*');
INSERT INTO `tb_permission` VALUES (36, '会员移除', '/member/remove/*');
INSERT INTO `tb_permission` VALUES (37, '会员启用', '/member/start/*');
INSERT INTO `tb_permission` VALUES (38, '会员停用', '/member/stop/*');
INSERT INTO `tb_permission` VALUES (39, '会员编辑', '/member/update/*');
INSERT INTO `tb_permission` VALUES (40, '权限添加', '/user/addPermission');
INSERT INTO `tb_permission` VALUES (41, '角色添加', '/user/addRole');
INSERT INTO `tb_permission` VALUES (42, '用户添加', '/user/addUser');
INSERT INTO `tb_permission` VALUES (43, '修改用户密码', '/user/changePass');
INSERT INTO `tb_permission` VALUES (44, '删除权限', '/user/delPermission/*');
INSERT INTO `tb_permission` VALUES (45, '删除角色', '/user/delRole/*');
INSERT INTO `tb_permission` VALUES (46, '删除用户', '/user/delUser/*');
INSERT INTO `tb_permission` VALUES (47, '用户启用', '/user/start/*');
INSERT INTO `tb_permission` VALUES (48, '用户停用', '/user/stop/*');
INSERT INTO `tb_permission` VALUES (49, '编辑权限', '/user/updatePermission');
INSERT INTO `tb_permission` VALUES (50, '编辑角色', '/user/updateRole');
INSERT INTO `tb_permission` VALUES (51, '编辑用户', '/user/updateUser');
INSERT INTO `tb_permission` VALUES (52, '编辑系统基本配置', '/sys/base/update');
INSERT INTO `tb_permission` VALUES (53, '删除系统日志', '/sys/log/del/*');
INSERT INTO `tb_permission` VALUES (54, '添加shiro配置', '/sys/shiro/add');
INSERT INTO `tb_permission` VALUES (55, '删除shiro配置', '/sys/shiro/del/*');
INSERT INTO `tb_permission` VALUES (56, '编辑shiro配置', '/sys/shiro/update');
INSERT INTO `tb_permission` VALUES (57, '删除订单', '/order/del/*');
INSERT INTO `tb_permission` VALUES (58, '添加捐赠', '/thanks/add');
INSERT INTO `tb_permission` VALUES (59, '删除捐赠', '/thanks/del/*');
INSERT INTO `tb_permission` VALUES (60, '编辑捐赠', '/thanks/update');
INSERT INTO `tb_permission` VALUES (61, '添加板块', '/panel/add');
INSERT INTO `tb_permission` VALUES (62, '删除版块', '/panel/del/*');
INSERT INTO `tb_permission` VALUES (63, '更新板块', '/panel/update');
INSERT INTO `tb_permission` VALUES (64, '更新首页缓存', '/redis/index/update');
INSERT INTO `tb_permission` VALUES (65, '更新推荐板块缓存', '/redis/recommend/update');
INSERT INTO `tb_permission` VALUES (66, '更新捐赠板块缓存', '/redis/thank/update');
INSERT INTO `tb_permission` VALUES (67, '同步索引', '/item/importIndex');
INSERT INTO `tb_permission` VALUES (69, '订单备注', '/order/remark');
INSERT INTO `tb_permission` VALUES (70, '订单发货', '/order/deliver');
INSERT INTO `tb_permission` VALUES (71, '取消订单', '/order/cancel/*');
INSERT INTO `tb_permission` VALUES (72, '快递添加', '/express/add');
INSERT INTO `tb_permission` VALUES (73, '快递编辑', '/express/update');
INSERT INTO `tb_permission` VALUES (74, '快递删除', '/express/del/*');
INSERT INTO `tb_permission` VALUES (75, '词典添加', '/dict/add');
INSERT INTO `tb_permission` VALUES (76, '词典编辑', '/dict/update');
INSERT INTO `tb_permission` VALUES (77, '词典删除', '/dict/del/*');
INSERT INTO `tb_permission` VALUES (78, '捐赠管理页面', '/thanks-list');
COMMIT;

-- ----------------------------
-- Table structure for tb_role
-- ----------------------------
DROP TABLE IF EXISTS `tb_role`;
CREATE TABLE `tb_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_role
-- ----------------------------
BEGIN;
INSERT INTO `tb_role` VALUES (1, '超级管理员', '拥有至高无上的权力');
INSERT INTO `tb_role` VALUES (2, '游客', '只是个过客');
COMMIT;

-- ----------------------------
-- Table structure for tb_role_perm
-- ----------------------------
DROP TABLE IF EXISTS `tb_role_perm`;
CREATE TABLE `tb_role_perm` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) DEFAULT NULL,
  `permission_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=304 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_role_perm
-- ----------------------------
BEGIN;
INSERT INTO `tb_role_perm` VALUES (246, 1, 17);
INSERT INTO `tb_role_perm` VALUES (247, 1, 18);
INSERT INTO `tb_role_perm` VALUES (248, 1, 19);
INSERT INTO `tb_role_perm` VALUES (249, 1, 20);
INSERT INTO `tb_role_perm` VALUES (250, 1, 21);
INSERT INTO `tb_role_perm` VALUES (251, 1, 23);
INSERT INTO `tb_role_perm` VALUES (252, 1, 24);
INSERT INTO `tb_role_perm` VALUES (253, 1, 25);
INSERT INTO `tb_role_perm` VALUES (254, 1, 27);
INSERT INTO `tb_role_perm` VALUES (255, 1, 28);
INSERT INTO `tb_role_perm` VALUES (256, 1, 29);
INSERT INTO `tb_role_perm` VALUES (257, 1, 30);
INSERT INTO `tb_role_perm` VALUES (258, 1, 31);
INSERT INTO `tb_role_perm` VALUES (259, 1, 33);
INSERT INTO `tb_role_perm` VALUES (260, 1, 34);
INSERT INTO `tb_role_perm` VALUES (261, 1, 35);
INSERT INTO `tb_role_perm` VALUES (262, 1, 36);
INSERT INTO `tb_role_perm` VALUES (263, 1, 37);
INSERT INTO `tb_role_perm` VALUES (264, 1, 38);
INSERT INTO `tb_role_perm` VALUES (265, 1, 39);
INSERT INTO `tb_role_perm` VALUES (266, 1, 40);
INSERT INTO `tb_role_perm` VALUES (267, 1, 41);
INSERT INTO `tb_role_perm` VALUES (268, 1, 42);
INSERT INTO `tb_role_perm` VALUES (269, 1, 43);
INSERT INTO `tb_role_perm` VALUES (270, 1, 44);
INSERT INTO `tb_role_perm` VALUES (271, 1, 45);
INSERT INTO `tb_role_perm` VALUES (272, 1, 46);
INSERT INTO `tb_role_perm` VALUES (273, 1, 47);
INSERT INTO `tb_role_perm` VALUES (274, 1, 48);
INSERT INTO `tb_role_perm` VALUES (275, 1, 49);
INSERT INTO `tb_role_perm` VALUES (276, 1, 50);
INSERT INTO `tb_role_perm` VALUES (277, 1, 51);
INSERT INTO `tb_role_perm` VALUES (278, 1, 52);
INSERT INTO `tb_role_perm` VALUES (279, 1, 53);
INSERT INTO `tb_role_perm` VALUES (280, 1, 54);
INSERT INTO `tb_role_perm` VALUES (281, 1, 55);
INSERT INTO `tb_role_perm` VALUES (282, 1, 56);
INSERT INTO `tb_role_perm` VALUES (283, 1, 57);
INSERT INTO `tb_role_perm` VALUES (284, 1, 58);
INSERT INTO `tb_role_perm` VALUES (285, 1, 59);
INSERT INTO `tb_role_perm` VALUES (286, 1, 60);
INSERT INTO `tb_role_perm` VALUES (287, 1, 61);
INSERT INTO `tb_role_perm` VALUES (288, 1, 62);
INSERT INTO `tb_role_perm` VALUES (289, 1, 63);
INSERT INTO `tb_role_perm` VALUES (290, 1, 64);
INSERT INTO `tb_role_perm` VALUES (291, 1, 65);
INSERT INTO `tb_role_perm` VALUES (292, 1, 66);
INSERT INTO `tb_role_perm` VALUES (293, 1, 67);
INSERT INTO `tb_role_perm` VALUES (294, 1, 69);
INSERT INTO `tb_role_perm` VALUES (295, 1, 70);
INSERT INTO `tb_role_perm` VALUES (296, 1, 71);
INSERT INTO `tb_role_perm` VALUES (297, 1, 72);
INSERT INTO `tb_role_perm` VALUES (298, 1, 73);
INSERT INTO `tb_role_perm` VALUES (299, 1, 74);
INSERT INTO `tb_role_perm` VALUES (300, 1, 75);
INSERT INTO `tb_role_perm` VALUES (301, 1, 76);
INSERT INTO `tb_role_perm` VALUES (302, 1, 77);
INSERT INTO `tb_role_perm` VALUES (303, 1, 78);
COMMIT;

-- ----------------------------
-- Table structure for tb_shiro_filter
-- ----------------------------
DROP TABLE IF EXISTS `tb_shiro_filter`;
CREATE TABLE `tb_shiro_filter` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `perms` varchar(255) DEFAULT NULL,
  `sort_order` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_shiro_filter
-- ----------------------------
BEGIN;
INSERT INTO `tb_shiro_filter` VALUES (1, '/login', 'anon', 1);
INSERT INTO `tb_shiro_filter` VALUES (2, '/403', 'anon', 2);
INSERT INTO `tb_shiro_filter` VALUES (3, '/', 'authc', 3);
INSERT INTO `tb_shiro_filter` VALUES (7, '/index', 'authc', 4);
INSERT INTO `tb_shiro_filter` VALUES (8, '/welcome', 'authc', 5);
INSERT INTO `tb_shiro_filter` VALUES (9, '/thanks-pic', 'authc', 6);
INSERT INTO `tb_shiro_filter` VALUES (10, '/lock-screen', 'authc', 7);
INSERT INTO `tb_shiro_filter` VALUES (11, '/user/logout', 'authc', 8);
INSERT INTO `tb_shiro_filter` VALUES (12, '/user/userInfo', 'authc', 9);
INSERT INTO `tb_shiro_filter` VALUES (17, '/content/cat/add', 'perms[/content/cat/add]', 10);
INSERT INTO `tb_shiro_filter` VALUES (18, '/content/cat/del/*', 'perms[/content/cat/del/*]', 11);
INSERT INTO `tb_shiro_filter` VALUES (19, '/content/cat/update', 'perms[/content/cat/update]', 12);
INSERT INTO `tb_shiro_filter` VALUES (21, '/content/add', 'perms[/content/add]', 13);
INSERT INTO `tb_shiro_filter` VALUES (22, '/content/del/*', 'perms[/content/del/*]', 14);
INSERT INTO `tb_shiro_filter` VALUES (23, '/content/update', 'perms[/content/update]', 15);
INSERT INTO `tb_shiro_filter` VALUES (24, '/image/imageUpload', 'perms[/image/imageUpload]', 16);
INSERT INTO `tb_shiro_filter` VALUES (25, '/image/update', 'perms[/image/update]', 18);
INSERT INTO `tb_shiro_filter` VALUES (26, '/kindeditor/imageUpload', 'perms[/kindeditor/imageUpload]', 17);
INSERT INTO `tb_shiro_filter` VALUES (27, '/item/cat/add', 'perms[/item/cat/add]', 19);
INSERT INTO `tb_shiro_filter` VALUES (28, '/item/cat/del/*', 'perms[/item/cat/del/*]', 20);
INSERT INTO `tb_shiro_filter` VALUES (29, '/item/cat/update', 'perms[/item/cat/update]', 21);
INSERT INTO `tb_shiro_filter` VALUES (30, '/item/add', 'perms[/item/add]', 22);
INSERT INTO `tb_shiro_filter` VALUES (31, '/item/del/*', 'perms[/item/del/*]', 23);
INSERT INTO `tb_shiro_filter` VALUES (32, '/item/start/*', 'perms[/item/start/*]', 24);
INSERT INTO `tb_shiro_filter` VALUES (33, '/item/stop/*', 'perms[/item/stop/*]', 25);
INSERT INTO `tb_shiro_filter` VALUES (34, '/item/update/*', 'perms[/item/update/*]', 26);
INSERT INTO `tb_shiro_filter` VALUES (36, '/member/add', 'perms[/member/add]', 28);
INSERT INTO `tb_shiro_filter` VALUES (37, '/member/changePass/*', 'perms[/member/changePass/*]', 29);
INSERT INTO `tb_shiro_filter` VALUES (38, '/member/del/*', 'perms[/member/del/*]', 30);
INSERT INTO `tb_shiro_filter` VALUES (39, '/member/remove/*', 'perms[/member/remove/*]', 31);
INSERT INTO `tb_shiro_filter` VALUES (40, '/member/start/*', 'perms[/member/start/*]', 32);
INSERT INTO `tb_shiro_filter` VALUES (41, '/member/stop/*', 'perms[/member/stop/*]', 33);
INSERT INTO `tb_shiro_filter` VALUES (42, '/member/update/*', 'perms[/member/update/*]', 34);
INSERT INTO `tb_shiro_filter` VALUES (43, '/user/addPermission', 'perms[/user/addPermission]', 35);
INSERT INTO `tb_shiro_filter` VALUES (44, '/user/addRole', 'perms[/user/addRole]', 36);
INSERT INTO `tb_shiro_filter` VALUES (45, '/user/addUser', 'perms[/user/addUser]', 37);
INSERT INTO `tb_shiro_filter` VALUES (46, '/user/changePass', 'perms[/user/changePass]', 38);
INSERT INTO `tb_shiro_filter` VALUES (47, '/user/delPermission/*', 'perms[/user/delPermission/*]', 39);
INSERT INTO `tb_shiro_filter` VALUES (48, '/user/delRole/*', 'perms[/user/delRole/*]', 40);
INSERT INTO `tb_shiro_filter` VALUES (49, '/user/delUser/*', 'perms[/user/delUser/*]', 41);
INSERT INTO `tb_shiro_filter` VALUES (50, '/user/start/*', 'perms[/user/start/*]', 42);
INSERT INTO `tb_shiro_filter` VALUES (51, '/user/stop/*', 'perms[/user/stop/*]', 43);
INSERT INTO `tb_shiro_filter` VALUES (52, '/user/updatePermission', 'perms[/user/updatePermission]', 44);
INSERT INTO `tb_shiro_filter` VALUES (53, '/user/updateRole', 'perms[/user/updateRole]', 45);
INSERT INTO `tb_shiro_filter` VALUES (54, '/user/updateUser', 'perms[/user/updateUser]', 46);
INSERT INTO `tb_shiro_filter` VALUES (55, '/sys/base/update', 'perms[/sys/base/update]', 47);
INSERT INTO `tb_shiro_filter` VALUES (56, '/sys/log/del/*', 'perms[/sys/log/del/*]', 48);
INSERT INTO `tb_shiro_filter` VALUES (57, '/sys/shiro/add', 'perms[/sys/shiro/add]', 49);
INSERT INTO `tb_shiro_filter` VALUES (58, '/sys/shiro/del/*', 'perms[/sys/shiro/del/*]', 50);
INSERT INTO `tb_shiro_filter` VALUES (59, '/sys/shiro/update', 'perms[/sys/shiro/update]', 51);
INSERT INTO `tb_shiro_filter` VALUES (60, '/order/del/*', 'perms[/order/del/*]', 52);
INSERT INTO `tb_shiro_filter` VALUES (61, '/thanks/add', 'perms[/thanks/add]', 53);
INSERT INTO `tb_shiro_filter` VALUES (62, '/thanks/del/*', 'perms[/thanks/del/*]', 54);
INSERT INTO `tb_shiro_filter` VALUES (63, '/thanks/update', 'perms[/thanks/update]', 55);
INSERT INTO `tb_shiro_filter` VALUES (66, '/*', 'authc', 9);
INSERT INTO `tb_shiro_filter` VALUES (67, '/geetestInit', 'anon', 3);
INSERT INTO `tb_shiro_filter` VALUES (68, '/pay-edit', 'anon', 3);
INSERT INTO `tb_shiro_filter` VALUES (69, '/panel/add', 'perms[/panel/add]', 56);
INSERT INTO `tb_shiro_filter` VALUES (70, '/panel/del/*', 'perms[/panel/del/*]', 57);
INSERT INTO `tb_shiro_filter` VALUES (71, '/panel/update', 'perms[/panel/update]', 58);
INSERT INTO `tb_shiro_filter` VALUES (72, '/redis/index/update', 'perms[/redis/index/update]', 59);
INSERT INTO `tb_shiro_filter` VALUES (73, '/redis/recommend/update', 'perms[/redis/recommend/update]', 60);
INSERT INTO `tb_shiro_filter` VALUES (74, '/redis/thank/update', 'perms[/redis/thank/update]', 61);
INSERT INTO `tb_shiro_filter` VALUES (75, '/item/importIndex', 'perms[/item/importIndex]', 62);
INSERT INTO `tb_shiro_filter` VALUES (76, '/order/remark', 'perms[/order/remark]', 63);
INSERT INTO `tb_shiro_filter` VALUES (77, '/order/deliver', 'perms[/order/deliver]', 64);
INSERT INTO `tb_shiro_filter` VALUES (78, '/order/cancel/*', 'perms[/order/cancel/*]', 65);
INSERT INTO `tb_shiro_filter` VALUES (79, '/express/add', 'perms[/express/add]', 66);
INSERT INTO `tb_shiro_filter` VALUES (80, '/express/update', 'perms[/express/update]', 67);
INSERT INTO `tb_shiro_filter` VALUES (81, '/express/del/*', 'perms[/express/del/*]', 68);
INSERT INTO `tb_shiro_filter` VALUES (82, '/dict/add', 'perms[/dict/add]', 69);
INSERT INTO `tb_shiro_filter` VALUES (83, '/dict/update', 'perms[/dict/update]', 70);
INSERT INTO `tb_shiro_filter` VALUES (84, '/dict/del/*', 'perms[/dict/del/*]', 71);
INSERT INTO `tb_shiro_filter` VALUES (85, '/thanks-list', 'perms[/thanks-list]', 72);
COMMIT;

-- ----------------------------
-- Table structure for tb_thanks
-- ----------------------------
DROP TABLE IF EXISTS `tb_thanks`;
CREATE TABLE `tb_thanks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nick_name` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `money` decimal(10,2) DEFAULT NULL,
  `info` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL COMMENT '通知邮箱',
  `state` int(11) DEFAULT '0' COMMENT '状态 0待审核 1确认显示  2驳回 3通过不展示',
  `pay_type` varchar(255) DEFAULT NULL COMMENT '支付方式',
  `order_id` varchar(255) DEFAULT NULL COMMENT '关联订单id',
  `date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_thanks
-- ----------------------------
BEGIN;
INSERT INTO `tb_thanks` VALUES (6, '小黄鱼', '18782059038@163.com', 1.00, '无', NULL, 1, 'Alipay', NULL, '2018-03-30 19:03:07');
COMMIT;

-- ----------------------------
-- Table structure for tb_user
-- ----------------------------
DROP TABLE IF EXISTS `tb_user`;
CREATE TABLE `tb_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL COMMENT '用户名',
  `password` varchar(32) NOT NULL COMMENT '密码 md5加密存储',
  `phone` varchar(20) DEFAULT NULL COMMENT '注册手机号',
  `email` varchar(50) DEFAULT NULL COMMENT '注册邮箱',
  `sex` varchar(2) DEFAULT '',
  `address` varchar(255) DEFAULT NULL,
  `state` int(11) DEFAULT '0',
  `description` varchar(255) DEFAULT NULL,
  `role_id` int(11) DEFAULT '0',
  `file` varchar(255) DEFAULT NULL COMMENT '头像',
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`) USING BTREE,
  UNIQUE KEY `phone` (`phone`) USING BTREE,
  UNIQUE KEY `email` (`email`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
-- Records of tb_user
-- ----------------------------
BEGIN;
INSERT INTO `tb_user` VALUES (1, 'admin', 'e10adc3949ba59abbe56e057f20f883e', '17621230884', '1012139570@qq.com', '男', NULL, 1, '超级管理员', 1, 'http://ow2h3ee9w.bkt.clouddn.com/1507866340369.png', '2017-09-05 21:27:54', '2017-10-18 22:57:08');
INSERT INTO `tb_user` VALUES (2, 'test', '098f6bcd4621d373cade4e832627b4f6', '12345678901', '123@qq.com', '女', NULL, 1, '游客', 0, NULL, '2017-09-05 21:27:54', '2018-04-18 14:35:19');
INSERT INTO `tb_user` VALUES (3, 'mic', '4eea1e5de59fbc61cb3ab480dbbf6a5f', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, '2019-07-23 02:28:28', '2019-07-23 02:28:28');
COMMIT;

DROP TABLE IF EXISTS `tb_comment`;
CREATE TABLE `tb_comment`  (
  `id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品评论主键',
  `order_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单id',
  `item_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品id',
  `star` tinyint(4) NULL DEFAULT 5 COMMENT '星级',
  `type` tinyint(4) NULL DEFAULT 1 COMMENT '类型: 1好评 2中评 3差评',
  `is_anoymous` bit(1) NULL DEFAULT b'0' COMMENT '是否匿名评价',
  `content` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '评价内容',
  `buyer_nick` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '买家昵称',
  `comment_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '评价时间',
  `is_public` bit(1) NULL DEFAULT b'1' COMMENT '是否公开',
  `is_valid` bit(1) NULL DEFAULT b'0' COMMENT '是否通过审核',
  `validation_user_id` bigint(20) NULL DEFAULT NULL COMMENT '审核人id',
  `validation_time` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',
  `validation_suggestion` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审核意见',
  `is_top` bit(1) NULL DEFAULT b'0' COMMENT '是否置顶',
  `user_id` bigint(20) NOT NULL COMMENT '评论用户id',
  `is_deleted` bit(1) NULL DEFAULT b'0' COMMENT '是否删除',
  `deletion_time` datetime(0) NULL DEFAULT NULL COMMENT '删除时间',
  `deletion_user_id` bigint(20) NULL DEFAULT NULL COMMENT '删除用户id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品评价表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tb_comment_picture
-- ----------------------------
DROP TABLE IF EXISTS `tb_comment_picture`;
CREATE TABLE `tb_comment_picture`  (
  `id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品评价图片id',
  `comment_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品评价id',
  `pic_path` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '图片路径',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品评价图片表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tb_comment_reply
-- ----------------------------
DROP TABLE IF EXISTS `tb_comment_reply`;
CREATE TABLE `tb_comment_reply`  (
  `id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评价回复id',
  `comment_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品评价id',
  `parent_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '评价回复自关联id(针对回复的回复)',
  `content` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '回复意见',
  `reply_time` datetime(0) NULL DEFAULT NULL COMMENT '回复时间',
  `reply_nick` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '回复人昵称',
  `user_id` bigint(20) NOT NULL COMMENT '回复人用户id',
  `is_deleted` bit(1) NULL DEFAULT b'0' COMMENT '是否删除',
  `deletion_time` datetime(0) NULL DEFAULT NULL COMMENT '删除时间',
  `deletion_user_id` bigint(20) NULL DEFAULT NULL COMMENT '删除用户id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品评价回复表' ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;
